<?php
$installer = $this;

$installer->startSetup();

/**
 * Create table 'featured/featured_products'
 */
$table = $installer->getConnection()
    ->newTable($installer->getTable('featured/products'))
    ->addColumn('featured_products_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(
        'identity'  => true,
        'unsigned'  => true,
        'nullable'  => false,
        'primary'   => true,
        ), 'Featured Products Id')
    ->addColumn('title', Varien_Db_Ddl_Table::TYPE_VARCHAR, 50, array(
        ), 'Featured Products Title')
    ->addColumn('is_random', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array(
        'nullable'  => false,
        'default'   => '0',
        ), 'Is Random')
    ->addColumn('show_qty', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array(
    		'nullable'  => false,
			'default'   => '8',
        ), 'Show Qty')
    ->addColumn('products', Varien_Db_Ddl_Table::TYPE_VARCHAR, 512, array(
        ), 'Products')
    ->addColumn('created', Varien_Db_Ddl_Table::TYPE_DATETIME, null, array(
        ), 'Created Date')
    ->addColumn('updated', Varien_Db_Ddl_Table::TYPE_DATETIME, null, array(
        ), 'Updated Date')
    ->setComment('Featured Products Table');
$installer->getConnection()->createTable($table);

$installer->endSetup();